Entity Relationships - Courses (COURSE)

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
COURSE	Course Details	COURSEID				Stores basic details of courses (e.g. course name, department, etc).
COURSESTREAM	Course Stream	STREAMID	COURSE	One to many	COURSEID	Stores details of course streams.
COURSEPERIOD	Course Period	CPERIODID	COURSESTREAM	One to many	COURSEID, STREAMID	Lists specific instances and dates / times of course streams being run.
TRCOURSES	Trainee-Courses Link	TRCOURSEID	COURSESTREAM	One to many	COURSEID, STREAMID	Lists trainees enrolled on course streams.
COURSEATTENDANCES	Course Attendance Marker	TRAINEEID, CPERIODID	TRCOURSES and COURSEPERIOD	One to many	(From TRCOURSES) TRAINEEID; (From COURSEPERIOD) CPERIODID	Lists attendance records for trainees on courses.
COURSEASSESSOR	Assessor-Courses Link	CASSESSORID	COURSEPERIOD	One to one	COURSEID, STREAMID, CPERIODID	Links courses to the assessors who run them.
COURSEMODULE	Module-Courses Link	CMODULEID, COURSEID	COURSEPERIOD	One to many	COURSEID, STREAMID, CPERIODID	Links courses to the modules the relate to.
COURSEVENUE	Course Venues	CVENUEID	COURSEPERIOD	One to one	CPERIODID	Links courses to the venue they take place at.
VENUE	Venue	VENUEID	COURSEVENUE	One to one	VENUEID	Stores details of venues.